Know How / Tutorial

Occasionally, we will import csv data to excel and found out excel does not recognize the text column as DATE format.  This will give us problem when we want to change the date format , i.e to mm/yyyy or mm-yyyy.   As above, Excel does not recognize  “2020-01” as DATE, hence we need to convert text …

Average HDB Price Over Last 5 years In above example, we use data queried from gov.sg and provide only screen shot for illustration purposes.  To create dashboard, we will utilize excel pivot function along with Slicers and Timeline filtering options.  1.Preparing Data in CSV format Prepare your raw data as shown below.  2. Create Pivot …

Get the Price list Query product price into CSV files Below is an example of web scraping of price into csv files using Python.  Not the best, but it does the job by using requests and beautifulsoup modules. there are other modules out there to do the same tasks, i.e Selenium and Scrapy,  < – …

To reuse your old laptop or desktop, we can install Ubuntu server and practice linux commands hands on.   If you don’t have access to spare device, you can install it inside Oracle virtual box, without messing up windows core system. Installing Ubuntu Server is straight forward. First, we have to ensure we have at least …

How to create USB Bootable Drive It is very convenient to have USB bootable drive as we do not need to keep all sorts of DVD discs.  When we need a linux installer, we burn Ubuntu image to USB drive and when we need a windows system, we burn Windows image.  First , get your …